Round 1 - Screening - SQL

In first round they asked a hard level sql question. It was on CoderPad, it is a interactive tool.

CASE WHEN

Typecasting

Slicing

Window Functions

CTEs (Common Table Expressions)

Round 2 - Python Coding

In this round, data set was given and there were five transformations were given to write using pandas or Py spark. I preferred pandas as Coder pad was supporting only pandas. It also involved 3 questions on API. We need to read data from an api, every information was given for that. and 5 question were asked in general, which involved past experience, spark optimization and pipeline design.

Round 3 - Fit Round

It was totally non-technical. They only asked past experience and hr related questions. Like what makes an engineer different from world, how someone can take responsibilities.